Ironic, negative or surprising
consequence/fact or
Catch-22. Unexpected result.
Usually follows a positive statement. Used as
bridging statement for dramatic effect, to a negative consequence/statement.
Probably stems from the phrase "you'll be kicking yourself for this one"